package com.sinosoft.cnmuseum.dao;


import java.util.ArrayList;
import java.util.List;

import com.sinosoft.commontools.record.Record;
import com.sinosoft.dbtools.operate.single.DBSingleTableActorMgr;


public class MbXtglQxglDao extends BaseDao{

	public MbXtglQxglDao() {
		this.actor = DBSingleTableActorMgr.getDBSingleTableActor("Mb_xtgl_qxgl");
	}
	
	public List<Integer> getCheckId(String roleid){
	      String userselect = "select * from mb_xtgl_qxgl where zdbh in ( select qxbm from mb_xtgl_jsqxgx where jsbm = '"+roleid+"')";
	      List<Record> selectlist = this.getBySql(userselect);
	      List<Integer> result = new ArrayList<Integer>();
	      if(selectlist!=null&&selectlist.size()>0){
	    	  for(Record sel:selectlist){
	    		  result.add(sel.getIntValue("zdbh"));
	    	  }
	      }
		return result;
	}

}
